<?php
class costant
{
	static function getWowClass()
	{
		$db = db::getDbIstance();
		$db->query("SELECT classid, classname FROM classes");
		return $db->fetch_combo_all_row();
	}
	
	static function getSignupStatusValueLevelZero()
	{
		$db = db::getDbIstance();
		$db->query("SELECT signupstatusid, signupstatusvalue FROM signupstatus WHERE signuplevel=0");
		return $db->fetch_combo_all_row();
	}
	
	static function getSignupStatusValueLevelOne()
	{
		$db = db::getDbIstance();
		$db->query("SELECT signupstatusid, signupstatusvalue FROM signupstatus WHERE signuplevel=1");
		return $db->fetch_combo_all_row();
	}
	
	static function getSignupStatusValue()
	{
		$db = db::getDbIstance();
		$db->query("SELECT signupstatusid, signupstatusvalue FROM signupstatus WHERE");
		return $db->fetch_combo_all_row();
	}
	
	static function getRole()
	{
		$db = db::getDbIstance();
		$db->query("SELECT roleid, rolename FROM role");
		return $db->fetch_combo_all_row();
	}
}
?>